package guoanmaker.provider.business.repository;

import guoanmaker.provider.business.model.OperatorCity;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;

import java.util.List;

/**
 *  
 *
 * @author huZhaoyu 
 * @ClassName: OperatorCityRepository
 * @Description: 开通城市Repository
 * @date 2017/6/27  
 */
public interface OperatorCityRepository extends JpaRepository<OperatorCity, String>, JpaSpecificationExecutor<OperatorCity> {
//	@Query("select u from OperatorUser u left join fetch u.roles r where u.username=:username")
//    public Optional<OperatorUser> findByUsername(@Param("username") String username);
    Integer countAllByIdIsNotNull();

    List<OperatorCity> findByStatus(Integer status);

    OperatorCity findByCityId(String cityId);
    
	


}